sqlx4k-mysql/io.github.smyrgeorge.sqlx4k.mysql/[native]MySQL

MySQL

class MySQL(url: String, username: String, password: String, options: Driver.Pool.Options = Driver.Pool.Options()) : IMySQL

The MySQL class provides a driver implementation for interacting with a MySQL database. It supports connection pooling, transactional operations, and executing SQL queries.

The connection URL should follow the nex pattern, as described by MySQL.

The generic format of the connection URL: mysql:///database?properties

Parameters

url

The connection URL for the MySQL database.

username

The username for authenticating with the database.

password

The password for authenticating with the database.

options

The optional configuration for the connection pool, such as min/max connections and timeout settings.

Constructors

MySQL

constructor(url: String, username: String, password: String, options: Driver.Pool.Options = Driver.Pool.Options())

Types

Companion

object Companion

class Tx(rt: <Error class: unknown class><out <Error class: unknown class>>, tx: <Error class: unknown class><out <Error class: unknown class>>) : Transaction

Implementation of the Transaction interface that provides methods to manage and execute transactional operations using SQL commands. Transactions are synchronized using a Mutex to maintain thread safety.